-- @owner: @chen
-- @date: 2025-11-21
-- @testpoint: D库建表语句支持ON/ TEXTIMAGE_ON，部分测试点合理报错

@conn PrimaryDbDmode;
--TEXTIMAGE_ON语法测试
create table t1_textimage_on_case001(a int) TEXTIMAGE_ON [test1];
create table t2_textimage_on_case001(a int) TEXTIMAGE_ON "test1";
create table t3_textimage_on_case001(a int) TEXTIMAGE_ON 'test1';
create table t4_textimage_on_case001(a int) TEXTIMAGE_ON $test1$;
create table t5_textimage_on_case001(a int) TEXTIMAGE_ON (test1);
create table t6_textimage_on_case001(a int) TEXTIMAGE_ON {test1};
create table t7_textimage_on_case001(a int) TEXTIMAGE_ON test1;
create table t8_textimage_on_case001(a int) TEXTIMAGE_ON begin;
create table t9_textimage_on_case001(a int) TEXTIMAGE_ON proc;

-- on 语法测试
create table t1_on_case001(a int) ON [default];
create table t2_on_case001(a int) ON "default";
create table t3_on_case001(a int) ON 'default';
create table t4_on_case001(a int) ON $default$;
create table t5_on_case001(a int) ON (default);
create table t6_on_case001(a int) ON {default};
create table t7_on_case001(a int) ON default;
create table t8_on_case001(a int) ON end;
create table t9_on_case001(a int) ON procedure;

--drop table
drop table if exists t1_textimage_on_case001;
drop table if exists t2_textimage_on_case001;
drop table if exists t3_textimage_on_case001;
drop table if exists t4_textimage_on_case001;
drop table if exists t5_textimage_on_case001;
drop table if exists t6_textimage_on_case001;
drop table if exists t7_textimage_on_case001;
drop table if exists t8_textimage_on_case001;
drop table if exists t9_textimage_on_case001;
drop table if exists t1_on_case001;
drop table if exists t2_on_case001;
drop table if exists t3_on_case001;
drop table if exists t4_on_case001;
drop table if exists t5_on_case001;
drop table if exists t6_on_case001;
drop table if exists t7_on_case001;
drop table if exists t8_on_case001;
drop table if exists t9_on_case001;